EMT Practice Test

1. Question Content...

---

Question1: Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.

Question2: What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question.

Question3: What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system? Please choose the correct answer.

Question4: The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery.

Question5: Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question.

Question6: Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store? There are 2 correct answers to this question.

Question7: Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.

Question8: What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.

Question9: What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

Question10: How can you shorten the delta merge runtime of a table?

Question11: In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA? There are 2 correct answers to this question.

Question12: How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

Question13: When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.

Question14: Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question.

Question15: The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

Question16: USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?

Question17: Why are repository roles preferred over catalog roles? Note: There are 2 correct answers.

Question18: You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default?

Question19: Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system?
Please choose the correct answer.

Question20: The network security policies of your project restrict direct SQL connections to the SAP HANA databases.
Which tools can you use to monitor the SAP HANA database? Note: There are 2 correct answers.

Question21: Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.

Question22: Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

Question23: You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?

Question24: Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? There are 2 correct answers to this question.

Question25: How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system? Note: There are 2 correct answers.

Question26: Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

Question27: What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.

Question28: What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? There are 2 correct answers to this question.

Question29: Which operations are performed by SAP Landscape Management? Note: There are 2 correct answers.

Question30: Which system privilege must you have to redistribute tables across the hosts in your scale-out system?

Question31: Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system. Which of the following options are listed? There are 3 correct answers to this question.

Question32: Which information can you analyze using the Troubleshoot Unresponsive System application?

Question33: Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

Question34: Which of the following recovery types is not supported for delta backups?

Question35: What do you do to prepare the database migration option of a Software Update Manager procedure? Note:
There are 3 correct answers.

Question36: You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?

Question37: You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace? There are 2 correct answers to this question.

Question38: Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers.

Question39: Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.

Question40: In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.

Question41: Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.

Question42: A user is complaining about missing privileges when executing a query. How do you configure the indexserver trace to obtain the missing privileges? Please choose the correct answer:.

Question43: How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.

Question44: You are installing several SAP HANA systems with a standard setup. How can you automate this activity?

Question45: How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.

Question46: When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.

Question47: A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

Question48: How do you trigger a savepoint in an SAP HANA database?

Question49: Which of the following actions are possible when managing roles? There are 3 correct answers to this question.

Question50: What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

Question51: During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.

Question52: What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

Question53: In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 correct answers to this question.

Question54: What can you use the Secure User Store (hdbuserstore) for? There are 2 correct answers to this question.

Question55: Which information is provided by the backup catalog. Please choose the correct answer:.

Question56: Which authentication method can you configure for single sign-on in a middleware/application server scenario.

Question57: You plan to set up an SAP HANA2.0 system on intel-based hardware platform. Which of the following operating systems can you use Note: There are 2 correct answers.

Question58: What is the additional disk space factor required during delta merge operations? Please choose the correct answer.

Question59: Which programming languages are supported when you develop an application on SAP HANA extended application services? Note: There are 2 correct answers.

Question60: You needt to integrate an existing SAP HANA2.0 SPS05 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?

Question61: What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

Question62: You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

Question63: What can a user do when the backup operator system privileges is assigned?

Question64: Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?
There are 2 correct answers to this question.

Question65: Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor?
There are 3 correct answers to this question.

Question66: Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question.

Question67: What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.

Question68: Which information is provided via the SUM Ul? There are 3 correct answers to this question.

Question69: A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system privileges do you assign to the technical user account on the target system?

Question70: In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).
However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions?
There are 2 correct answers to this question.

Question71: Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Question72: Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers.

Question73: Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit?
There are 2 correct answers to this question.

Question74: Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.

Question75: You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.

Question76: What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

Question77: What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases?
There are 2 correct answers to this question.

Question78: Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

Question79: What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question.

Question80: Which SAP HANA cockpit application can you use to investigate a system offline situation? Please choose the correct answer.

Question81: For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

Question82: What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.

Question83: Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.

Question84: What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases?